﻿<?xml version="1.0" encoding="utf-8" ?>
<ConnectionStrings>
  <ConnectionString name="SQLServer(mdf file)" DB="SQLServer">
Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;AttachDbFilename={MdfFileName};Integrated Security=SSPI
  </ConnectionString>
  <ConnectionString name="SQLServer" DB="SQLServer">
Provider=SQLOLEDB;Data Source={ServerAddress};Initial Catalog={Catalog};User Id={UserId};Password={Password};
  </ConnectionString>
  <ConnectionString name="Oracle" DB="Oracle">
Provider=OraOLEDB.Oracle;Data Source={TNSName};User Id={UserId};Password={Password};OLEDB.NET=True;
  </ConnectionString>
  <ConnectionString name="MySQL" DB="MySQL">
Provider=MySQLProv;Data Source={DataSource};User Id={UserId};Password={Password};
  </ConnectionString>
  <ConnectionString name="Access" DB="Access">
Provider=Microsoft.Jet.OLEDB.4.0;Data Source={AccessFileName};Jet OLEDB:Database Password={DBPassword};
  </ConnectionString>
  <ConnectionString name="Access2007" DB="Access">
Provider=Microsoft.ACE.OLEDB.12.0;Data Source={AccessFileName};Jet OLEDB:Database Password={DBPassword};
  </ConnectionString>
  <ConnectionString name="Excel2003" DB="Excel">
Provider=Microsoft.Jet.OLEDB.4.0;Data Source={ExcelFileName};Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
  </ConnectionString>
  <ConnectionString name="Excel2007" DB="Excel">
Provider=Microsoft.ACE.OLEDB.12.0;Data Source={ExcelFileName};Extended Properties="Excel 12.0 Xml;HDR=YES";
  </ConnectionString>
  <ConnectionString name="Txt" DB="Txt">
Provider=Microsoft.Jet.OLEDB.4.0;Data Source={FolderName};Extended Properties="text;HDR=Yes;FMT=Delimited";
  </ConnectionString>
</ConnectionStrings>